package cn.swust.designpatternlearningplatform.dao.sql;

import org.apache.ibatis.jdbc.SQL;

public class SelfTrainingDaoSql {
    public String getAllPoint(){
        return new SQL(){
            {
                SELECT("*");
                FROM("knowledge_point");
            }
        }.toString();
    }
    public String getTopicByPointId(Integer pointId){
        return new SQL(){
            {
                SELECT("topic_id");
                FROM("topic_knowledge_correlation");
                WHERE("point_id=#{pointId}");
            }
        }.toString();
    }
}
